Spread ASP.NET 16
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / SetConditionalFormatting Method / SetConditionalFormatting(Int32,Int32,Int32,Int32,IConditionalFormattingRule[]) Method
Starting row index
Starting column index
Number of rows
Number of columns
The specified rules to apply for a specified range of cells
Example


In This Topic
    SetConditionalFormatting(Int32,Int32,Int32,Int32,IConditionalFormattingRule[]) Method
    In This Topic
    Sets conditional formatting for a specified range of cells on the sheet based on specified rules.
    Syntax
    'Declaration
     
    Public Overloads Sub SetConditionalFormatting( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal rowCount As Integer, _
       ByVal columnCount As Integer, _
       ByVal ParamArray rules() As IConditionalFormattingRule _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim row As Integer
    Dim column As Integer
    Dim rowCount As Integer
    Dim columnCount As Integer
    Dim rules() As IConditionalFormattingRule
     
    instance.SetConditionalFormatting(row, column, rowCount, columnCount, rules)
    public void SetConditionalFormatting( 
       int row,
       int column,
       int rowCount,
       int columnCount,
       params IConditionalFormattingRule[] rules
    )

    Parameters

    row
    Starting row index
    column
    Starting column index
    rowCount
    Number of rows
    columnCount
    Number of columns
    rules
    The specified rules to apply for a specified range of cells
    Example
    This example uses the SetConditionalFormatting method.
    See Also